package mybbs;

import java.sql.ResultSet;

public class DetailPostInfo extends PostInfo {
private String userid, username,nickname,isqualify,e_mail,skype,mobile,
signature,usergrade,reg_time,last_time,info,face,online;
public String getIsqualify() {
	return isqualify;
}
public void setIsqualify(String isqualify) {
	this.isqualify = isqualify;
}
private int userscore,userpower,totalpost;
public void setPostid(int id){
	super.setPostid(id);
	this.setUserid(""+super.getAuthorid());
}
public String getUserid() {
	return userid;
}
public void setUserid(String userid) {
	this.userid = userid;
	try{
		  DBConn conn=new DBConn();
		  String sql="SELECT * FROM bbsuser WHERE id="+userid;
		  ResultSet rs=conn.query(sql);
		   rs.next();
		    username=rs.getString("username");
		    nickname=rs.getString("nickname");
		    e_mail=rs.getString("email");
		    skype=rs.getString("skype");
		    mobile=rs.getString("mobile");
		    signature=rs.getString("signature");
		    usergrade=rs.getString("usergrade");
		    reg_time=rs.getString("reg_time");
		    last_time=rs.getString("last_time");
		    info=rs.getString("info");
		    userscore=rs.getInt("userscore");
		    userpower=rs.getInt("userpower");
		    totalpost=rs.getInt("totalpost");
		    face=rs.getString("face");
		    online=rs.getString("online");
		    isqualify=rs.getString("isqualify");
		    rs.close();
		    conn.DBclose();
		      }
		   catch(Exception e){}
}
public String getUsername() {
	return username;
}
public String getNickname() {
	return nickname;
}
public String getE_mail() {
	return e_mail;
}
public String getSkype() {
	return skype;
}
public String getMobile() {
	return mobile;
}
public String getSignature() {
	return signature;
}
public String getUsergrade() {
	return usergrade;
}
public String getReg_time() {
	return reg_time;
}
public String getLast_time() {
	return last_time;
}
public String getInfo() {
	return info;
}
public String getFace() {
	return face;
}
public int getUserscore() {
	return userscore;
}
public int getUserpower() {
	return userpower;
}
public int getTotalpost() {
	return totalpost;
}
public void setOnline(String online) {
	this.online = online;
}
public String getOnline() {
	return online;
}

}
